TemporaryPriceChangeItem

Entity Definition

Logical Name : TemporaryPriceChangeItem
Physical Name : MA_ITM_TMP_PRC_CHN

This association between a TEMPORARY PRICE CHANGE and ITEM establishes the application of a new permanent price (or percentage or monetary increase or decrease) for an item. A TEMPORARY PRICE CHANGE is posted to an ITEM for a predefined period of time marked by beginning and ending date and time. TEMPORARY PRICE CHANGEs are posted to an item and are applied in all transaction involving that item.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
BusinessUnitGroupID (FK)(PK) A unique system assigned identifier for a group of BusinessUnits. ID_BSNGP Identity integer BusinessUnitGroupItem(AS_BSNGP_ITM)
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) BusinessUnitGroupItem(AS_BSNGP_ITM)
EffectiveDateTime (FK)(PK) The date from which the BusinessUnits in the group carry the Item. TS_EF EffectiveDateTime datetime BusinessUnitGroupItem(AS_BSNGP_ITM)
EventID (FK)(PK) A unique, automatically assigned identifier for the Event ID_EV Identity integer TemporaryPriceChange(TR_CHN_TMP_PRC)
NewPrice The new Temporary Retail Price to be applied to the Item in all stores in the RetailStoreGroup as a consequence of the PriceChangeEvent MO_PRC_NW MoneyShortRetail decimal(7,2)

Relationships

Parent Entity Verb Phrase Child Entity
BusinessUnitGroupItem has price changed by TemporaryPriceChangeItem
TemporaryPriceChange changes price for TemporaryPriceChangeItem

Logical Views containing TemporaryPriceChangeItem

Logical View
Logical 01300 - Item Price Maintenance View
Logical 06700 - Event Scheduler View